--options(skip=1)
load data
characterset  UTF8 
--infile ''
append into table I_AAA_CUSTOMER
fields terminated by X'09' --一个tab，分隔符
TRAILING NULLCOLS (
USERNAME,
SERVICETYPE,
AREANO,
PAYTYPE,
GROUPID,
NASIP,
BINDTYPE,
BINDATTR,
LIMITUSERS,
STATUS,
OPENDATE date 'YYYY-MM-DD HH24:MI:SS',
EFFECTDATE date 'YYYY-MM-DD HH24:MI:SS',
EXPIREDATE date 'YYYY-MM-DD HH24:MI:SS',
CLOSEDATE	date 'YYYY-MM-DD HH24:MI:SS',
BANDWIDTH,
BILLINGDATE	date 'YYYY-MM-DD HH24:MI:SS',
ROAMLEVEL,
OPTIONALSERvice,
UPBANDWIDTH,
ID "SEQ_I_AAA_CUSTOMER.NEXTVAL"  --使用序列，序列放在最后一列进行自动添加
)

--sqlldr userid=obasdev/obasdev@DB control='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\user_info.ctl' data='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\user_info_201305132035.txt' log='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\user_info.log' parallel=true
